Skip to main content
GoldenGate

The Replicat Abended with OGG-02615

By February 7, 2024April 1st, 2024No Comments6 min read

When the Replicat process in Oracle GoldenGate abends with error code OGG-02615, it indicates an issue related to data mapping between the source and target databases. This error typically occurs when the Replicat process encounters data that does not conform to the defined mapping rules. Here’s how you can troubleshoot and address this issue:

It failed to start, and after checking the report file, I found the below error.

ERROR   OGG-02615  Login to the database as user ggadmin failed because of error ORA-28001: the password has expired

Below are the standard practices to troubleshoot any abended process issues:

  • Review Replicat Parameters
  • Review Error Details
  • Examining Trail Files
  • Verifying data consistent
  • etc

Now let’s review the report file of the process:


2024-03-15 11:29:59  INFO    OGG-06153  FIPS 140 support has been enabled. Process 28570 is using compliant shared libraries to perform encryption for the rest of its execution.

***********************************************************************
                 Oracle GoldenGate Delivery for Oracle
 Version 21.12.0.0.3 OGGCORE_21.12.0.0.0OGGRU_PLATFORMS_231115.1435_FBO
 Oracle Linux 7, x64, 64bit (optimized), Oracle Database 21c and lower supported versions on Nov 15 2023 19:25:58
 
Copyright (C) 1995, 2023, Oracle and/or its affiliates. All rights reserved.

                    Starting at 2024-03-15 11:29:59
***********************************************************************

Operating System Version:
Linux
Version #2 SMP Fri Jan 19 12:49:30 PST 2024, Release 4.14.35-2047.533.3.el7uek.x86_64
Node: inst-prod-vn0ajcqilrfv
Machine: x86_64
                         soft limit   hard limit
Address Space Size   :    unlimited    unlimited
Heap Size            :    unlimited    unlimited
File Size            :    unlimited    unlimited
CPU Time             :    unlimited    unlimited

Process id: 28570

Description: 

***********************************************************************
**            Running with the following parameters                  **
***********************************************************************

2024-03-15 11:29:59  INFO    OGG-03059  Operating system character set identified as UTF-8.

2024-03-15 11:29:59  INFO    OGG-02695  ANSI SQL parameter syntax is used for parameter parsing.

2024-03-15 11:29:59  INFO    OGG-01360  REPLICAT is running in Parallel mode.
REPLICAT RJDQA
USERIDALIAS CRDSADWQA DOMAIN OracleGoldenGate

Source Context :
  SourceModule            : [ggdb.ora.OraRepConnUtil]
  SourceID                : [../gglib/ggdbora/OraRepConnUtil.cpp]
  SourceMethod            : [openDataSource]
  SourceLine              : [95]
  ThreadBacktrace         : [13] elements
                          : [/u01/ogg/bin/../lib/libgglog.so(CMessageContext::AddThreadContext())]
                          : [/u01/ogg/bin/../lib/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...))]
                          : [/u01/ogg/bin/../lib/libgglog.so(_MSG_LoginName_String(CSourceContext*, int, ggs::gglib::ggapp::CDBObjName<(DBObjType)11> const&, char const*, CMessageFactory::MessageDisposition))]
                          : [/u01/ogg/bin/replicat()]
                          : [/u01/ogg/bin/replicat(odbc_param(char*, char*, ggs::gglib::ggapp::ReplicationContextParams const&))]
                          : [/u01/ogg/bin/replicat(get_infile_params(ggs::gglib::ggapp::ReplicationContextParams&, ggs::gglib::ggdatasource::DataSourceParams&, ggs::gglib::ggdatatarget::DataTargetParams&, ggs::gglib::ggmetadata::MetadataContext&))]
                          : [/u01/ogg/bin/replicat()]
                          : [/u01/ogg/bin/replicat(ggs::gglib::MultiThreading::MainThread::ExecMain())]
                          : [/u01/ogg/bin/replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*))]
                          : [/u01/ogg/bin/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]
                          : [/u01/ogg/bin/replicat(main)]
                          : [/lib64/libc.so.6(__libc_start_main)]
                          : [/u01/ogg/bin/replicat()]

2024-03-15 11:30:03  ERROR   OGG-02615  Login to the database as user ggadmin failed because of error ORA-28001: the password has expired.

Source Context :
  SourceModule            : [ggdb.ora.ocicpp.err]
  SourceID                : [ggdbora/ocicpp/OCIErrorHandler.cpp]
  SourceMethod            : [dpiErr]
  SourceLine              : [133]
  ThreadBacktrace         : [19] elements
                          : [/u01/ogg/bin/../lib/libgglog.so(CMessageContext::AddThreadContext())]
                          : [/u01/ogg/bin/../lib/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...))]
                          : [/u01/ogg/bin/../lib/libgglog.so(_MSG_Int32_String_String(CSourceContext*, int, int, char const*, char const*, CMessageFactory::MessageDisposition))]
                          : [/u01/ogg/bin/replicat(ggs::gglib::ggocicpp::OCIErrorHandler::dpiErr(dpi::Exception&) const)]
                          : [/u01/ogg/bin/replicat(ggs::gglib::ggocicpp::OCIConnection::connect(ggs::gglib::ggdbconnection::DBConnectionParams const&))]
                          : [/u01/ogg/bin/replicat(ggs::gglib::ggocicpp::OCIEnvironment::createConnection(ggs::gglib::ggdbconnection::DBConnectionParams const&))]
                          : [/u01/ogg/bin/replicat(ggs::gglib::ggocicpp::ORAConnection::initConn(ggs::gglib::ggdbconnection::DBConnectionParams const&, ULibCharSet, ULibCharSet))]
                          : [/u01/ogg/bin/replicat(ggs::gglib::ggocicpp::ORARepConnection::makeConnection(ULibCharSet, ULibCharSet))]
                          : [/u01/ogg/bin/replicat(ggs::gglib::ggocicpp::ORARepConnection::createRepConnection(ggs::gglib::ggdbconnection::DBConnectionParams const&, ULibCharSet, ULibCharSet))]
                          : [/u01/ogg/bin/replicat(ggs::gglib::ggdbora::OraRepConnUtil::openDataSource(ggs::gglib::ggdbapi::DBAuthParams&))]
                          : [/u01/ogg/bin/replicat(odbc_param(char*, char*, ggs::gglib::ggapp::ReplicationContextParams const&))]
                          : [/u01/ogg/bin/replicat(get_infile_params(ggs::gglib::ggapp::ReplicationContextParams&, ggs::gglib::ggdatasource::DataSourceParams&, ggs::gglib::ggdatatarget::DataTargetParams&, ggs::gglib::ggmetadata::MetadataContext&))]
                          : [/u01/ogg/bin/replicat()]
                          : [/u01/ogg/bin/replicat(ggs::gglib::MultiThreading::MainThread::ExecMain())]
                          : [/u01/ogg/bin/replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*))]
                          : [/u01/ogg/bin/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]
                          : [/u01/ogg/bin/replicat(main)]
                          : [/lib64/libc.so.6(__libc_start_main)]
                          : [/u01/ogg/bin/replicat()]

2024-03-15 11:30:03  ERROR   OGG-00664  OCI Error ORA (status = 28001-ORA-28001: the password has expired
).
2024-03-15 11:30:03  ERROR   OGG-01668  PROCESS ABENDING.

After reviewing the log, it is observed that the Password has expired, and the user account status is below

Changed the password since the account is expired

After changing the password at the Database, now we should apply in OGG configuration like below

OGG (https://127.0.0.1:7123 ORA-X1) 11> ALTER CREDENTIALSTORE REPLACE USER ggadmin@(DESCRIPTION=(TRANSPORT_CONNECT_TIMEOUT=3)(CONNECT_TIMEOUT=60)(RECV_TIMEOUT=120)(retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=bmjgquen.adb.us-ashburn1.oraclecloud.com))(CONNECT_DATA=(COLOCATION_TAG=DVOCIADLPOGG01)(FAILOVER_MODE=(TYPE=SESSION)(METHOD=BASIC)(OVERRIDE=TRUE))(service_name=ge56ab843aa8863_crdsadwqa_low.adb.oraclecloud.com))(security=(MY_WALLET_DIRECTORY=”/u02/connections/ocid1.goldengateconnection.oc1.iad.amaaaaaalbyzsdqad6luj44tzwfo7nid7nsbqcqshcr4cfut46wlpzsxdmgq/wallet”)(ssl_server_dn_match=no))) PASSWORD 0r@Kleadm2024 ALIAS ORA-X1 DOMAIN OracleGoldenGate

2024-03-18T18:17:46Z  INFO    OGG-15114  Credential store altered.

OGG (https://127.0.0.1:7123 ORA-X1) 12> DBLOGIN USERIDALIAS CRDSADWQA

Successfully logged into database.

Now start the replicate process:

Note: Whenever the ggadmin user password expires on the target side, or In case of password change at the database level due to security reasons, then we need to change it at the GoldenGate level as well as above.

Leave a Reply